USING THE NEW FUNCTIONS IN APPLEWORKS V.3 SPREADSHEET
By Dave Stock
Copyright (c) 1990 Apple Users' Group, Sydney
Republished from Applecations, a publication of the Apple Users' Group, Sydney, Australia.
At long last one can process labels in Appleworks. Before version 3 you could not use labels in your formulae. In the last issue of Applecations we had a spreadsheet template for your power bill which broke power usage into SEASONS for comparisons. Here is a formula which will automatically convert the numbers of the month into SEASONS.
First of all though, making use of only one row, put SUMMER in cell C, in cell D put AUTUMN, into E put WINTER and into F type SPRING.
Referring to these cells saves heaps of space for our formula, rather than actually typing the words directly into the formula. Now for the magic formula which consists of four nested 'IF' statements. Into cell B carefully type these 55 characters:
@IF(A1>11,C1,@IF(A1>8,F1,@IF(A1>5,E1,@IF(A1>2,D1,C1))))
Don't forget the opening bracket after each @IF, and the closing four at the end. Make sure that you get your 'greater than' signs correct and check each comma.
Now in cell A type any number from 1 to 12. As you enter each number, cell B should come up with the season of that month of the year, that is, provided you ignore the weather and you live in the Southern Hemisphere.

THIS CONTENT COPYRIGHT © 2007, APPLE MACINTOSH USERS' GROUP, SYDNEY
Permission has been obtained to make this material available on the Internet.

Permission is hereby granted for non-profit user groups to republish this content.
PLEASE CREDIT THE AUTHOR AND THE SOURCE: Applecations, publication of the Apple Users' Group, Sydney, Australia

THIS PAGE COPYRIGHT © 2007, ANDREW ROUGHAN